In [13]:
pip install ydata_profiling
Requirement already satisfied: ydata_profiling in ./anaconda3/lib/python3.11/site-packages (4.6.4)
Requirement already satisfied: scipy<1.12,>=1.4.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.11.1)
Requirement already satisfied: pandas!=1.4.0,<3,>1.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (2.0.3)
Requirement already satisfied: matplotlib<3.9,>=3.2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (3.7.2)
Requirement already satisfied: pydantic>=2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (2.6.1)
Requirement already satisfied: PyYAML<6.1,>=5.0.0 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (6.0)
Requirement already satisfied: jinja2<3.2,>=2.11.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (3.1.2)
Requirement already satisfied: visions[type_image_path]==0.7.5 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.7.5)
Requirement already satisfied: numpy<1.26,>=1.16.0 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.24.3)
Requirement already satisfied: htmlmin==0.1.12 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.1.12)
Requirement already satisfied: phik<0.13,>=0.11.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.12.4)
Requirement already satisfied: requests<3,>=2.24.0 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (2.31.0)
Requirement already satisfied: tqdm<5,>=4.48.2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (4.65.0)
Requirement already satisfied: seaborn<0.13,>=0.10.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.12.2)
Requirement already satisfied: multimethod<2,>=1.4 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.11)
Requirement already satisfied: statsmodels<1,>=0.13.2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.14.0)
Requirement already satisfied: typeguard<5,>=4.1.2 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (4.1.5)
Requirement already satisfied: imagehash==4.3.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (4.3.1)
Requirement already satisfied: wordcloud>=1.9.1 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.9.3)
Requirement already satisfied: dacite>=1.8 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (1.8.1)
Requirement already satisfied: numba<0.59.0,>=0.56.0 in ./anaconda3/lib/python3.11/site-packages (from ydata_profiling) (0.57.1)
Requirement already satisfied: PyWavelets in ./anaconda3/lib/python3.11/site-packages (from imagehash==4.3.1->ydata_profiling) (1.4.1)
Requirement already satisfied: pillow in ./anaconda3/lib/python3.11/site-packages (from imagehash==4.3.1->ydata_profiling) (9.4.0)
Requirement already satisfied: attrs>=19.3.0 in ./anaconda3/lib/python3.11/site-packages (from visions[type_image_path]==0.7.5->ydata_profiling) (22.1.0)
Requirement already satisfied: networkx>=2.4 in ./anaconda3/lib/python3.11/site-packages (from visions[type_image_path]==0.7.5->ydata_profiling) (3.1)
Requirement already satisfied: tangled-up-in-unicode>=0.0.4 in ./anaconda3/lib/python3.11/site-packages (from visions[type_image_path]==0.7.5->ydata_profiling) (0.2.0)
Requirement already satisfied: MarkupSafe>=2.0 in ./anaconda3/lib/python3.11/site-packages (from jinja2<3.2,>=2.11.1->ydata_profiling) (2.1.1)
Requirement already satisfied: contourpy>=1.0.1 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (1.0.5)
Requirement already satisfied: cycler>=0.10 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (0.11.0)
Requirement already satisfied: fonttools>=4.22.0 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (4.25.0)
Requirement already satisfied: kiwisolver>=1.0.1 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (1.4.4)
Requirement already satisfied: packaging>=20.0 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (23.1)
Requirement already satisfied: pyparsing<3.1,>=2.3.1 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (3.0.9)
Requirement already satisfied: python-dateutil>=2.7 in ./anaconda3/lib/python3.11/site-packages (from matplotlib<3.9,>=3.2->ydata_profiling) (2.8.2)
Requirement already satisfied: llvmlite<0.41,>=0.40.0dev0 in ./anaconda3/lib/python3.11/site-packages (from numba<0.59.0,>=0.56.0->ydata_profiling) (0.40.0)
Requirement already satisfied: pytz>=2020.1 in ./anaconda3/lib/python3.11/site-packages (from pandas!=1.4.0,<3,>1.1->ydata_profiling) (2023.3.post1)
Requirement already satisfied: tzdata>=2022.1 in ./anaconda3/lib/python3.11/site-packages (from pandas!=1.4.0,<3,>1.1->ydata_profiling) (2023.3)
Requirement already satisfied: joblib>=0.14.1 in ./anaconda3/lib/python3.11/site-packages (from phik<0.13,>=0.11.1->ydata_profiling) (1.2.0)
Requirement already satisfied: annotated-types>=0.4.0 in ./anaconda3/lib/python3.11/site-packages (from pydantic>=2->ydata_profiling) (0.6.0)
Requirement already satisfied: pydantic-core==2.16.2 in ./anaconda3/lib/python3.11/site-packages (from pydantic>=2->ydata_profiling) (2.16.2)
Requirement already satisfied: typing-extensions>=4.6.1 in ./anaconda3/lib/python3.11/site-packages (from pydantic>=2->ydata_profiling) (4.7.1)
Requirement already satisfied: charset-normalizer<4,>=2 in ./anaconda3/lib/python3.11/site-packages (from requests<3,>=2.24.0->ydata_profiling) (2.0.4)
Requirement already satisfied: idna<4,>=2.5 in ./anaconda3/lib/python3.11/site-packages (from requests<3,>=2.24.0->ydata_profiling) (3.4)
Requirement already satisfied: urllib3<3,>=1.21.1 in ./anaconda3/lib/python3.11/site-packages (from requests<3,>=2.24.0->ydata_profiling) (1.26.16)
Requirement already satisfied: certifi>=2017.4.17 in ./anaconda3/lib/python3.11/site-packages (from requests<3,>=2.24.0->ydata_profiling) (2023.7.22)
Requirement already satisfied: patsy>=0.5.2 in ./anaconda3/lib/python3.11/site-packages (from statsmodels<1,>=0.13.2->ydata_profiling) (0.5.3)
Requirement already satisfied: six in ./anaconda3/lib/python3.11/site-packages (from patsy>=0.5.2->statsmodels<1,>=0.13.2->ydata_profiling) (1.16.0)
Note: you may need to restart the kernel to use updated packages.
In [14]:
pip install pandas
Requirement already satisfied: pandas in ./anaconda3/lib/python3.11/site-packages (2.0.3)
Requirement already satisfied: python-dateutil>=2.8.2 in ./anaconda3/lib/python3.11/site-packages (from pandas) (2.8.2)
Requirement already satisfied: pytz>=2020.1 in ./anaconda3/lib/python3.11/site-packages (from pandas) (2023.3.post1)
Requirement already satisfied: tzdata>=2022.1 in ./anaconda3/lib/python3.11/site-packages (from pandas) (2023.3)
Requirement already satisfied: numpy>=1.21.0 in ./anaconda3/lib/python3.11/site-packages (from pandas) (1.24.3)
Requirement already satisfied: six>=1.5 in ./anaconda3/lib/python3.11/site-packages (from python-dateutil>=2.8.2->pandas) (1.16.0)
Note: you may need to restart the kernel to use updated packages.
In [17]:
from ydata_profiling import ProfileReport
import pandas as pd
In [7]:
df = pd.read_csv('Food_Inspections_20240216.tsv',sep ='\t')
print(df)
        Inspection ID                              DBA Name  \
0             2589576                        Drippin' Bites   
1             2589517               GRAND BEER WINE SPIRITS   
2             2589485        CASA CENTRAL COMMUNITY SERVICE   
3             2589362                    BARTOLI'S PIZZERIA   
4             2589343                           LUNCH HEROS   
...               ...                                   ...   
267608         197240                              CINNABON   
267609         114316                        HARD ROCK CAFE   
267610          60258  HOOK FISH & CHICKEN ON MADISON, INC.   
267611         120277                       POLK STREET CO.   
267612          78260           DR DETON J BROOKS HEADSTART   

                                    AKA Name  License #  \
0                             Drippin' Bites  2952306.0   
1                    GRAND BEER WINE SPIRITS  2923772.0   
2             CASA CENTRAL COMMUNITY SERVICE    60765.0   
3                         BARTOLI'S PIZZERIA  2709388.0   
4                                LUNCH HEROS  2951905.0   
...                                      ...        ...   
267608                              CINNABON  1846783.0   
267609                        HARD ROCK CAFE    51236.0   
267610  HOOK FISH & CHICKEN ON MADISON, INC.  1868125.0   
267611                       POLK STREET CO.    29507.0   
267612           DR DETON J BROOKS HEADSTART    51035.0   

                          Facility Type             Risk  \
0                                   NaN    Risk 1 (High)   
1                         Grocery Store     Risk 3 (Low)   
2                            Restaurant    Risk 1 (High)   
3                            Restaurant    Risk 1 (High)   
4                            Restaurant    Risk 1 (High)   
...                                 ...              ...   
267608                              NaN  Risk 2 (Medium)   
267609                       Restaurant    Risk 1 (High)   
267610                       Restaurant  Risk 2 (Medium)   
267611                       Restaurant    Risk 1 (High)   
267612  Daycare Above and Under 2 Years    Risk 1 (High)   

                         Address     City State      Zip Inspection Date  \
0            6808 N SHERIDAN RD   CHICAGO    IL  60626.0      02/14/2024   
1              1142 W GRAND AVE   CHICAGO    IL  60642.0      02/13/2024   
2         1343 N CALIFORNIA AVE   CHICAGO    IL  60622.0      02/13/2024   
3             658 N ASHLAND AVE   CHICAGO    IL  60622.0      02/08/2024   
4            2273 N LINCOLN AVE   CHICAGO    IL  60614.0      02/08/2024   
...                          ...      ...   ...      ...             ...   
267608       151 N MICHIGAN AVE   CHICAGO    IL  60601.0      01/27/2010   
267609          63 W ONTARIO ST   CHICAGO    IL  60654.0      02/03/2010   
267610         3952 W MONROE ST   CHICAGO    IL  60624.0      01/14/2010   
267611            548 W POLK ST   CHICAGO    IL  60607.0      01/06/2010   
267612  6921 S STONY ISLAND AVE   CHICAGO    IL  60649.0      01/15/2010   

                Inspection Type             Results  \
0                       License           Not Ready   
1                       License                Pass   
2                       Canvass                Pass   
3                       Canvass                Fail   
4                       License           Not Ready   
...                         ...                 ...   
267608          Out of Business                Fail   
267609                  Canvass  Pass w/ Conditions   
267610  Complaint Re-Inspection                Pass   
267611                  Canvass                Fail   
267612                  Canvass                Pass   

                                               Violations   Latitude  \
0                                                     NaN  42.005827   
1                                                     NaN  41.891202   
2                                                     NaN  41.905986   
3       48. WAREWASHING FACILITIES: INSTALLED, MAINTAI...  41.894209   
4                                                     NaN  41.923574   
...                                                   ...        ...   
267608                                                NaN  41.884540   
267609  21. * CERTIFIED FOOD MANAGER ON SITE WHEN POTE...  41.893128   
267610                                                NaN  41.879875   
267611  18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...  41.872113   
267612  34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOO...  41.769129   

        Longitude                                  Location  
0      -87.661140   (42.00582694496218, -87.66114012527682)  
1      -87.656295    (41.89120176033192, -87.6562947219871)  
2      -87.696807   (41.90598597077873, -87.69680735572291)  
3      -87.667382  (41.894208809612294, -87.66738222845791)  
4      -87.645932    (41.9235739992025, -87.64593222667874)  
...           ...                                       ...  
267608 -87.624309   (41.88454011059238, -87.62430852246028)  
267609 -87.630563   (41.89312775453658, -87.63056251830054)  
267610 -87.725290     (41.8798749138472, -87.7252903599048)  
267611 -87.641305   (41.87211261426958, -87.64130525460628)  
267612 -87.585827   (41.76912914412988, -87.58582746167004)  

[267613 rows x 17 columns]
In [19]:
profile = ProfileReport(df,title = 'Food_Inspections_Report' )
In [20]:
profile.to_notebook_iframe()
Summarize dataset:   0%|          | 0/5 [00:00<?, ?it/s]
Generate report structure:   0%|          | 0/1 [00:00<?, ?it/s]
Render HTML:   0%|          | 0/1 [00:00<?, ?it/s]
In [ ]: